You will also need to prefix all of your inserts and updates etc with N' for Unicode Character Format or Unicode Native format.
-----Original Message----- From: Ergün KOÇAK [mailto:[EMAIL PROTECTED] Sent: 30 March 2005 13:05 To: SQL Subject: Collation Problem 2 Sorry for first message it was not utf8 so it had charachter problems here is the true characters --------------------------------------------- Hello, I have an "SQL_Latin1_General_CP1_CI_AS" database. But till now some coders entered Turkish characters into it with Coldfusion 5. Table columns are varchar and text. When looked into tables with Enterprise manager the turkish characters are seen wrong. Because Turkish characters are written to the database with conversiton they converted the Turkish characters to their "SQL_Latin1_General_CP1_CI_AS" equvalents for example they converted ı ( short I, not i ) to ý . now when a create a database with "SQL_Latin1_General_CP1_CI_AS" collation and hit "ı" it writes to db "ý" i fill a column with these types of characters and then i run this script (column MMMMMM is varchar(50)) ALTER DATABASE XXXXX COLLATE Turkish_CI_AS ALTER TABLE ZZZZZ ALTER COLUMN MMMMMM nvarchar(50) ALTER TABLE ZZZZZ ALTER COLUMN MMMMMM nvarchar(50) COLLATE Turkish_CI_AS but when i do this sql server puts "?" for "ý". So tried ALTER DATABASE XXXXX COLLATE Turkish_CI_AS ALTER TABLE ZZZZZ ALTER COLUMN MMMMMM varchar(50) COLLATE Turkish_CI_AS ALTER TABLE ZZZZZ ALTER COLUMN MMMMMM nvarchar(50) this time SQL server puts "ý" for "ý". Seems ok ? But when i use CFMX 7.0 to select data from table and write it to screen it shows "ý" not "ı". Would you recommed any script or tool which can do this conversation ? Best Regards... Ergun KOCAK www.websiteci.com/ergun ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
