Select Record with Chinese Return None

From: Silas (silas01_at_netvigator.com)
Date: 05/13/04

  • Next message: David L: "Re: DB fixup after migration" 
    Date: Thu, 13 May 2004 12:01:59 +0800

    Hi,

    I have a problems for select record from SQL2000 with criteria has a Chinese
    character.

    (e.g. select * from customer where customer_name = 'XXXX' )
    ('XXXX' - Chinese char).

    I got no record returned and I sure that there is a record with customer
    name is 'XXXX'.

    I tried setup to collation by the result is the same. I'm using SQL2000 sp3
    under WIN2000 server.

    Thanks for you help.

    Regards,
    Silas

  • Next message: David L: "Re: DB fixup after migration"

    Relevant Pages

    • How to search words starting with a particular char?
      ... I need to search how many words are starting with a specific character ... I search all occurencies that's matching my criteria in the resulting ... Best regards. ...
      (comp.lang.ruby)
    • Re: Tsilang Translation file for chinese language
      ... Best regards. ... TsiLang Components Suite - Best Globalization Tool 2004 ... > Importing in the Dictionnary doesn't show me chinese char, ... Prev by Date: ...
      (borland.public.delphi.thirdpartytools.general)
    • Re: Select Record with Chinese Return None
      ... >I have a problems for select record from SQL2000 with criteria has a Chinese ... >('XXXX' - Chinese char). ... >I got no record returned and I sure that there is a record with customer ... >under WIN2000 server. ...
      (microsoft.public.sqlserver)
    Loading