Home

Private: Code & Script Snippet

Every thing you imagin, study it – know it – use it

Problem with searching thai text in ms sql

Try this :

Select * from Table1 WHERE (ColumnName like N’%Values%’)

Select * from Table1 WHERE (ColumnName = N’%Values%’)

or

Select * from Table1 Where (ColumnName collate Thai_bin like N’%Values%’)

Select * from Table1 Where (ColumnName collate Thai_bin = N’%Values%’)

1 comment to Problem with searching thai text in ms sql

Ilias

November 24th, 2009 at 6:54 pm

Interesting, I`ll quote it on my site later.
[url=http://www.purimblog.net/]Ilias[/url]

Leave a Reply

Copyright © 2010 Private: Code & Script Snippet - All Rights Reserved
Powered by WordPress & the Atahualpa Theme by BytesForAll. Discuss on our WP Forum