They will need to be nvarchar to store Unicode characters.
-----Original Message----- From: Erg�n KO�AK [mailto:[EMAIL PROTECTED] Sent: 30 March 2005 12:59 To: SQL Subject: Collation Problem 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 i ( short I, not i ) to � . now when a create a database with "SQL_Latin1_General_CP1_CI_AS" collation and hit "i" 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 "i". 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:2227 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
