Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Chinese character

2 posts in Internet Last posting was on 1999-12-18 23:51:14.0Z
Thomas Tsang Posted on 1999-12-18 05:21:22.0Z
Message-ID: <385B19D2.E0540399@hkc.net>
Date: Sat, 18 Dec 1999 13:21:22 +0800
From: Thomas Tsang <thomast@hkc.net>
Organization: Hong Kong Communications Computer Ltd. Co.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Chinese character
Content-Type: multipart/mixed; boundary="------------002B8F7A5CB122EED1EBD1B8"
Newsgroups: sybase.public.sqlserver.internet
Lines: 36
NNTP-Posting-Host: 202.146.123.120
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:384
Article PK: 1067440

Hi All,


Currently I am using Sybase v11.92, and I face a problem when a
Chinese character. When I add a Chinese character string into a field
of which the type is varchar(20), I find the database will only store 6
- 7 Chinese characters, I know that one Chinese character will use 2
storage space, but I don't know why it can't store 10 Chinese
characters, and the no. of Chinese character it stored is not fixed.

Do I miss any configuration in the database setting?

Thank you


Thomas Tsang


Download VCard thomast.vcf


Bret Halford Posted on 1999-12-18 23:51:14.0Z
Message-ID: <385C1DF2.5354@sybase.com>
Date: Sat, 18 Dec 1999 16:51:14 -0700
From: Bret Halford <bret@sybase.com>
Organization: Customer Service & Support
X-Mailer: Mozilla 3.0 (X11; U; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Thomas Tsang <thomast@hkc.net>
Subject: Re: Chinese character
References: <385B19D2.E0540399@hkc.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.internet
Lines: 20
NNTP-Posting-Host: alliance1.sybase.com 157.133.214.40
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.internet:383
Article PK: 1067441


Thomas Tsang wrote:
>
> Hi All,
>
> Currently I am using Sybase v11.92, and I face a problem when a
> Chinese character. When I add a Chinese character string into a field
> of which the type is varchar(20), I find the database will only store 6
> - 7 Chinese characters, I know that one Chinese character will use 2
> storage space, but I don't know why it can't store 10 Chinese
> characters, and the no. of Chinese character it stored is not fixed.
>
> Do I miss any configuration in the database setting?
>

Hi Thomas,

Are you sure you aren't using the UTF-8 (UNICODE) character set?
My recollection is that it uses 3 bytes per Chinese character.

-bret
--
Bret Halford
Sybase Technical Support
3665 Discovery Drive
Boulder, CO 80303