1 Reply Latest reply on Jun 19, 2008 8:53 PM by Newsgroup_User

    CF5 & Unicode

    Prof_Fugem Level 1
      Is anyone aware of a method using CF5 to insert cyrillic characters into a SQL2K5 database?

      I've tried..
      update table set column = N'[value]'
      update table set column = <cfquery param

      ...to no avail

      I am dealing with Czech, Polish, Russiam, and Slovak characters.

      I am willing to convert to html entities if that will work.

      Thanks in advance
        • 1. Re: CF5 &amp; Unicode
          Level 7
          Prof Fugem wrote:
          > Is anyone aware of a method using CF5 to insert cyrillic characters into a
          > SQL2K5 database?

          sure just make sure your data, cf pages, etc are all utf-8 & yoru text columsn
          are all "N" types. but this approach is doomed to failure. you won't be able to
          properly sort, search, etc the data (it's raw utf-8) & you will eventually
          *have* to redo all this when you upgrade to cfmx. if possible bite the bullet &
          upgrade now.