Skip to main content
P
Prof_Fugem
Participant
June 19, 2008
Question

CF5 & Unicode

  • June 19, 2008
  • 1 reply
  • 191 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
June 20, 2008
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices