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.

Interactive SQL and Unicode and Chinese characters

6 posts in General Discussion Last posting was on 2008-06-16 15:28:44.0Z
gz Posted on 2008-06-09 18:59:28.0Z
Sender: 1048.484d7973.1804289383@sybase.com
From: gz
Newsgroups: ianywhere.public.general
Subject: Interactive SQL and Unicode and Chinese characters
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <484d7d90.10d0.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2008 11:59:28 -0700
X-Trace: forums-1-dub 1213037968 10.22.241.41 (9 Jun 2008 11:59:28 -0700)
X-Original-Trace: 9 Jun 2008 11:59:28 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6882
Article PK: 5113

Hi,

I am using Interactive SQL to do some queries. One field of
the query is of type nchar(). It contains Chinese characters
encoded in UTF-8. However, Interactive SQL is not able to
display the results in the Results pane. It only shows
little empty boxes in place of the characters.

Does anyone know how to solve this problem.

Thanks,
gz


Josh Savill Posted on 2008-06-09 20:15:29.0Z
From: Josh Savill <no_spam_jsavill@ianywhere.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL and Unicode and Chinese characters
References: <484d7d90.10d0.1681692777@sybase.com>
In-Reply-To: <484d7d90.10d0.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484d8f61$1@forums-1-dub>
Date: 9 Jun 2008 13:15:29 -0700
X-Trace: forums-1-dub 1213042529 10.22.241.152 (9 Jun 2008 13:15:29 -0700)
X-Original-Trace: 9 Jun 2008 13:15:29 -0700, vip152.sybase.com
Lines: 19
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6883
Article PK: 5114

What are the Regional and Languages Options set on your machine?

--
Joshua Savill
Sybase iAnywhere - Product Manager

gz wrote:
> Hi,
>
> I am using Interactive SQL to do some queries. One field of
> the query is of type nchar(). It contains Chinese characters
> encoded in UTF-8. However, Interactive SQL is not able to
> display the results in the Results pane. It only shows
> little empty boxes in place of the characters.
>
> Does anyone know how to solve this problem.
>
> Thanks,
> gz


gz Posted on 2008-06-09 20:59:36.0Z
Sender: 15c6.484d965c.1804289383@sybase.com
From: gz
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL and Unicode and Chinese characters
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <484d99b8.168a.1681692777@sybase.com>
References: <484d8f61$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2008 13:59:36 -0700
X-Trace: forums-1-dub 1213045176 10.22.241.41 (9 Jun 2008 13:59:36 -0700)
X-Original-Trace: 9 Jun 2008 13:59:36 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6885
Article PK: 5116


> What are the Regional and Languages Options set on your
> machine?

US English. But notepad is able to display Chinese
characters in UTF-8 encoding.


"Frank Ploessel" <fpl... Posted on 2008-06-09 20:21:04.0Z
Subject: Re: Interactive SQL and Unicode and Chinese characters
From: "Frank Ploessel" <fpl...@d_e.i_m_s_h_e_a_l_t_h.c_o_m>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
References: <484d7d90.10d0.1681692777@sybase.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.uchz5jauj0bybf@computer>
User-Agent: Opera Mail/9.25 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 9 Jun 2008 13:21:04 -0700
X-Trace: forums-1-dub 1213042864 10.22.241.152 (9 Jun 2008 13:21:04 -0700)
X-Original-Trace: 9 Jun 2008 13:21:04 -0700, vip152.sybase.com
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6884
Article PK: 5115

GZ,

I would check that the font selected in Tools/Options/Results can display
Chinese characters. On Western European versions of Windows, you would
have to install Asian characters for that to be the case, and even then
some fonts do not contain all Asian characters.

Frank

On Mon, 09 Jun 2008 20:59:28 +0200, <gz> wrote:

> Hi,
>
> I am using Interactive SQL to do some queries. One field of
> the query is of type nchar(). It contains Chinese characters
> encoded in UTF-8. However, Interactive SQL is not able to
> display the results in the Results pane. It only shows
> little empty boxes in place of the characters.
>
> Does anyone know how to solve this problem.
>
> Thanks,
> gz


gz Posted on 2008-06-10 01:22:32.0Z
Sender: 1faf.484dc409.1804289383@sybase.com
From: gz
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL and Unicode and Chinese characters
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <484dd758.2237.1681692777@sybase.com>
References: <op.uchz5jauj0bybf@computer>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2008 18:22:32 -0700
X-Trace: forums-1-dub 1213060952 10.22.241.41 (9 Jun 2008 18:22:32 -0700)
X-Original-Trace: 9 Jun 2008 18:22:32 -0700, 10.22.241.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6886
Article PK: 5117

This worked.

I cannot find any "system font" that can display Chinese,
but if I choose editor font, it just works.

Thanks.

> GZ,
>
> I would check that the font selected in
> Tools/Options/Results can display Chinese characters. On
> Western European versions of Windows, you would have to
> install Asian characters for that to be the case, and even
> then some fonts do not contain all Asian characters.
>
> Frank
>
> On Mon, 09 Jun 2008 20:59:28 +0200, <gz> wrote:
>
> > Hi,
> >
> > I am using Interactive SQL to do some queries. One field
> > of the query is of type nchar(). It contains Chinese
> > characters encoded in UTF-8. However, Interactive SQL is
> > not able to display the results in the Results pane. It
> > only shows little empty boxes in place of the
> characters. >
> > Does anyone know how to solve this problem.
> >
> > Thanks,
> > gz
>


Chris Irie Posted on 2008-06-16 15:28:44.0Z
From: "Chris Irie" <irie_spam_free@sybase.com>
Newsgroups: ianywhere.public.general
References: <484d7d90.10d0.1681692777@sybase.com>
Subject: Re: Interactive SQL and Unicode and Chinese characters
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <485686ac$1@forums-1-dub>
Date: 16 Jun 2008 08:28:44 -0700
X-Trace: forums-1-dub 1213630124 10.22.241.152 (16 Jun 2008 08:28:44 -0700)
X-Original-Trace: 16 Jun 2008 08:28:44 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6909
Article PK: 5135

DBISQL attempts to use your desktop font to display results in the Results
pane. You can see boxes instead of characters if your desktop font does not
contain glyphs for the characters in your results.

In version 10.0.1, you can choose the font to use for results on the
"Results" tab of DBISQL's "Options" dialog. I prefer a Unicode font like
"Arial Unicode MS" so I don't have to keep switching fonts.

If you are using an older version of DBISQL, you can also fix this by
selecting a Unicode font (e.g. Arial Unicode MS) for your desktop's "Icon"
items. Here's how to do that on XP:

0. Close DBISQL. Use Task Manager to confirm that there are no other
running instances of DBISQL. If there are, terminate them.
1. Right-click your desktop, click Properties
2. In the "Display Properties" window, click "Appearance", then click
"Advanced"
3. In the "Advanced Appearance" window, select "Icon" in the "Item" field,
then select "Arial Unicode MS" in the "Font" field.
4. Click OK to close the "Advanced Appearance" window
5. Click OK to close the "Display Properties" window
6. Start DBISQL.

-- Chris Irie
iAnywhere Solutions

<gz> wrote in message news:484d7d90.10d0.1681692777@sybase.com...
> Hi,
>
> I am using Interactive SQL to do some queries. One field of
> the query is of type nchar(). It contains Chinese characters
> encoded in UTF-8. However, Interactive SQL is not able to
> display the results in the Results pane. It only shows
> little empty boxes in place of the characters.
>
> Does anyone know how to solve this problem.
>
> Thanks,
> gz