COLLATE can be used in a WHERE clause to compare data in different collationg sequences as in
WHERE TABLE1.A = TABLEB.A COLLATE Latin1_General_CI_AS
Make a copy of the database and convert all the database VARCHAR to NVARCHAR. The casting should be in the old set of stored procedures. The simplest way forward however would be to update the delphi program
to use NVARCHAR. That way the conversion issue will no longer arise.
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
TATWORTH
All-Star
72405 Points
14018 Posts
MVP
Re: utf-8 in database varchar
May 23, 2007 06:37 AM|LINK
COLLATE can be used in a WHERE clause to compare data in different collationg sequences as in
WHERE TABLE1.A = TABLEB.A COLLATE Latin1_General_CI_AS
Make a copy of the database and convert all the database VARCHAR to NVARCHAR. The casting should be in the old set of stored procedures. The simplest way forward however would be to update the delphi program to use NVARCHAR. That way the conversion issue will no longer arise.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239