Chinise, Japanise, Korean character not on PDF

My report has Chinise, Japanise, and Korean characters and they look fine on
the SQL report services viewer, but when we export to PDF, the unicode
character are replaced by question marks "'". We are using the latest sp
of SQL report services. Any ideas?Hi
Did you get your chinese characters from the database? I stored mine in the
database in utf-8 format, but when displayed in report designer and report
server, the chinese characters do not appear, instead it shows exactly the
utf-8 string eg "&4fd;". Seems the "&" character is being replaced by "&",
what some people call escape sequence
"wheresaldo" wrote:
> My report has Chinise, Japanise, and Korean characters and they look fine on
> the SQL report services viewer, but when we export to PDF, the unicode
> character are replaced by question marks "'". We are using the latest sp
> of SQL report services. Any ideas?|||Well, for my testing onlyh I didn't store the chinese character on the
database, I just copy/paste chinese in the report editor. The chinese
character look great on the report viewer, but when I export to PDF, I just
get question marks instead, '.
If we decide to use the SQL report services, the chinese will be stored on a
database, so if you find a solution to your problem, please share it with me,
Than you,
"Chiara" wrote:
> Hi
> Did you get your chinese characters from the database? I stored mine in the
> database in utf-8 format, but when displayed in report designer and report
> server, the chinese characters do not appear, instead it shows exactly the
> utf-8 string eg "&4fd;". Seems the "&" character is being replaced by "&",
> what some people call escape sequence
> "wheresaldo" wrote:
> > My report has Chinise, Japanise, and Korean characters and they look fine on
> > the SQL report services viewer, but when we export to PDF, the unicode
> > character are replaced by question marks "'". We are using the latest sp
> > of SQL report services. Any ideas?

chinese characters with Unicode data types?

Hi,
I read that Unicode data types (like nchar or nvarchar)
support any characters of any language in the world. As we
need a database that supports many different languages, I
have tried to paste chinese characters into one table
field - although the field's data type is nvarchar, it
pastes only squares (instead of the chinese characters)
Can someone please help?
Thanks in advance,
BodoOne possibility is that the data is actually stored correctly in the
database, but the query tool you are using hasn't been configured to use a
font that defines glyphs for Chinese characters. Try using Query Analyzer
to both insert and view the data (don't use the "Show All Rows" view in
Enterprise Manager as the controls used in this view aren't Unicode aware).
Go to Tools --> Options --> Fonts tab, and select a font that supports
Chinese like "SimSun" or "Arial Unicode MS" for the "Results Text" and
"Results Grid" views.
Bart
--
Please reply to the newsgroup only - thanks.
This posting is provided "AS IS" with no warranties, and confers no rights.
Content-Class: urn:content-classes:message
From: "bodo" <bodobecker@.hotmail.com>
Sender: "bodo" <bodobecker@.hotmail.com>
Subject: chinese characters with Unicode data types?
Date: Sat, 13 Sep 2003 09:11:57 -0700
Lines: 14
Message-ID: <000a01c37a11$c15c4bf0$a401280a@.phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcN6EcFc9/ArRhOoTrW8Ejd9PK+XmQ==Newsgroups: microsoft.public.sqlserver.server
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:306274
NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
X-Tomcat-NG: microsoft.public.sqlserver.server
Hi,
I read that Unicode data types (like nchar or nvarchar)
support any characters of any language in the world. As we
need a database that supports many different languages, I
have tried to paste chinese characters into one table
field - although the field's data type is nvarchar, it
pastes only squares (instead of the chinese characters)
Can someone please help?
Thanks in advance,
Bodo

Checklist for SQL Server

Hi guys
Can anyone provide me some checklist to verify that SQL 2000 is unicode
enabled . In short how do i test the same
Help is appreciated !
Regards
SierraSierra wrote:
> Hi guys
> Can anyone provide me some checklist to verify that SQL 2000 is
> unicode enabled . In short how do i test the same
> Help is appreciated !
> Regards
> Sierra
You use unicode data by using nchar, nvarchar, and ntext data types in
your tables. If you don't use those data types, you can't store unicode
data.
--
David Gugick
Imceda Software
www.imceda.com|||Perhaps I don't fully understand your question but all SQL Server 2000
instances are 'unicode enabled'. One can store unicode data in nchar,
nvarchar or ntext data types.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
news:%23q3lulO2EHA.3392@.TK2MSFTNGP10.phx.gbl...
> Hi guys
> Can anyone provide me some checklist to verify that SQL 2000 is unicode
> enabled . In short how do i test the same
> Help is appreciated !
> Regards
> Sierra
>|||Hi Dan
Thanks for the response
I want to know how to check if a particular database and its tables,
related scripts, stored procedures, etc are Unicode-enabled in SQL 2000
Do you have any info on Test Statergy for the same
Regards
Sierra
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:ezaPjOP2EHA.1192@.tk2msftngp13.phx.gbl...
> Perhaps I don't fully understand your question but all SQL Server 2000
> instances are 'unicode enabled'. One can store unicode data in nchar,
> nvarchar or ntext data types.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
> news:%23q3lulO2EHA.3392@.TK2MSFTNGP10.phx.gbl...
> > Hi guys
> >
> > Can anyone provide me some checklist to verify that SQL 2000 is unicode
> > enabled . In short how do i test the same
> >
> > Help is appreciated !
> >
> > Regards
> > Sierra
> >
> >
>|||The scripts below will identify non-unicode character types in tables and
views as well as stored procedure and function parameters.
It's probably best to perform unicode testing as part of your overall
application testing strategy. Include unicode test data and cases in your
testing suite. This will identify issues with application code as well as
SQL objects and scripts.
--list character columns not unicode types
SELECT TOP 10
c.TABLE_SCHEMA,
c.TABLE_NAME,
c.COLUMN_NAME,
c.DATA_TYPE
FROM INFORMATION_SCHEMA.TABLES t
JOIN INFORMATION_SCHEMA.COLUMNS c ON
c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
c.TABLE_NAME = t.TABLE_NAME
WHERE
c.DATA_TYPE IN('char', 'varchar', 'text') AND
t.TABLE_TYPE = 'BASE TABLE'
--list stored procedure and function character parameters not unicode types
SELECT TOP 10
SPECIFIC_SCHEMA,
SPECIFIC_NAME,
PARAMETER_NAME,
DATA_TYPE
FROM INFORMATION_SCHEMA.PARAMETERS
WHERE
DATA_TYPE IN('char', 'varchar', 'text')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
news:u0a4ka52EHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi Dan
> Thanks for the response
> I want to know how to check if a particular database and its tables,
> related scripts, stored procedures, etc are Unicode-enabled in SQL 2000
> Do you have any info on Test Statergy for the same
> Regards
> Sierra
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:ezaPjOP2EHA.1192@.tk2msftngp13.phx.gbl...
>> Perhaps I don't fully understand your question but all SQL Server 2000
>> instances are 'unicode enabled'. One can store unicode data in nchar,
>> nvarchar or ntext data types.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
>> news:%23q3lulO2EHA.3392@.TK2MSFTNGP10.phx.gbl...
>> > Hi guys
>> >
>> > Can anyone provide me some checklist to verify that SQL 2000 is unicode
>> > enabled . In short how do i test the same
>> >
>> > Help is appreciated !
>> >
>> > Regards
>> > Sierra
>> >
>> >
>>
>|||Thanks Dan
Sierra
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:ebiT3252EHA.3932@.TK2MSFTNGP12.phx.gbl...
> The scripts below will identify non-unicode character types in tables and
> views as well as stored procedure and function parameters.
> It's probably best to perform unicode testing as part of your overall
> application testing strategy. Include unicode test data and cases in your
> testing suite. This will identify issues with application code as well as
> SQL objects and scripts.
> --list character columns not unicode types
> SELECT TOP 10
> c.TABLE_SCHEMA,
> c.TABLE_NAME,
> c.COLUMN_NAME,
> c.DATA_TYPE
> FROM INFORMATION_SCHEMA.TABLES t
> JOIN INFORMATION_SCHEMA.COLUMNS c ON
> c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
> c.TABLE_NAME = t.TABLE_NAME
> WHERE
> c.DATA_TYPE IN('char', 'varchar', 'text') AND
> t.TABLE_TYPE = 'BASE TABLE'
> --list stored procedure and function character parameters not unicode
types
> SELECT TOP 10
> SPECIFIC_SCHEMA,
> SPECIFIC_NAME,
> PARAMETER_NAME,
> DATA_TYPE
> FROM INFORMATION_SCHEMA.PARAMETERS
> WHERE
> DATA_TYPE IN('char', 'varchar', 'text')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
> news:u0a4ka52EHA.1292@.TK2MSFTNGP10.phx.gbl...
> > Hi Dan
> >
> > Thanks for the response
> >
> > I want to know how to check if a particular database and its tables,
> > related scripts, stored procedures, etc are Unicode-enabled in SQL 2000
> >
> > Do you have any info on Test Statergy for the same
> >
> > Regards
> >
> > Sierra
> >
> >
> >
> > "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> > news:ezaPjOP2EHA.1192@.tk2msftngp13.phx.gbl...
> >> Perhaps I don't fully understand your question but all SQL Server 2000
> >> instances are 'unicode enabled'. One can store unicode data in nchar,
> >> nvarchar or ntext data types.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Dan Guzman
> >> SQL Server MVP
> >>
> >> "Sierra" <senthilvel_sundaram@.yahoo.com> wrote in message
> >> news:%23q3lulO2EHA.3392@.TK2MSFTNGP10.phx.gbl...
> >> > Hi guys
> >> >
> >> > Can anyone provide me some checklist to verify that SQL 2000 is
unicode
> >> > enabled . In short how do i test the same
> >> >
> >> > Help is appreciated !
> >> >
> >> > Regards
> >> > Sierra
> >> >
> >> >
> >>
> >>
> >
> >
>