:) the scripts are doing this but first times the columns were varchar i have problems when converting them to nvarchar and Turkish_CI_AS collation.
Ergun KOCAK ----- Original Message ----- From: Robertson-Ravo, Neil (RX) To: SQL Sent: Wednesday, March 30, 2005 2:56 PM Subject: RE: Collation Problem 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2229 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
