Thanks RaspenJho for your input. Seems we need to find another way. Cheers.
Grasshopper
@Grasshopper
Best posts made by Grasshopper
Latest posts made by Grasshopper
-
RE: T-SQL 'Contains' predicate: question
-
T-SQL 'Contains' predicate: question
I have an MS-SQL database with full-text indexing enabled on a table.
I know I can use the Contains predicate to search the table for values, ie:
Select * from Table1 where Contains(Column1, 'MyText')
.. I know I can use a wildcard to find all rows where a column's data starts with a particular combination of characters, ie:
Select * from Table1 where Contains(Column1, ' "MyText*" ')
Now here's my question: Is there a way to find all rows wheres a column's data ENDS with a particular combination of characters? the obvious solution (putting the wildcard at the start of the search criteria) doesn't work.
Has anyone encountered the same problem and found a solution?
-
RE: Upgrading an ASP.Net/SQL2000 application to support Chinese (GB18030) characters
Thanks Dr. Pizza that's very useful info.
My understanding is that the GB18030 maps directly to all UTF-16 code points, and then extends over & above that to cater for a greater number of tradional chinese characters. On that basis is it fair to say that SQL2000 could never fully support the full GB18030 character set?
I'd be interested in hearing about any experiences you (or anyone else) may have had with this sort of localisation task? Anything else to watch out for?
Cheers.
-
Upgrading an ASP.Net/SQL2000 application to support Chinese (GB18030) characters
Hello All,
I've got an ASP.Net application with an SQL Server 2000 back-end that I'd like to upgrade so it can handle chinese language (input & display, with text searching & sorting).
I know I'll have to change all my varchar fields to nvarchar and prefix all strings with N'. I've got as far as reading the GB18030 standard and know that this is not supported in SQL2000. I'm a bit confused with the various forms of unicode support and how this then flows through to GB18030 compliance.
Can anyone offer some practical advice or experience on these matters?
Cheers.