Customer Name in Hebrew not displaying correctly

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Customer Name in Hebrew not displaying correctly

Author

Topic

jimmyjazz1978
Starting Member

11 Posts

Posted - 2012-04-20 : 08:50:55

Hi Gurus of SQL,

I imported a file with the customer name field in Hebrew for some Israeli Customers. It is coming up with funny characters in the database . How do I see it correctly in the database ? All the other customer names in that column are in English .

Collation of a single column to Hebrew ? Possible ? Convert the column from varchar to nvarchar ?

Bizzare

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2012-04-20 : 10:32:16

How are you viewing the data? Is the data incorrect or is the program you are using the view the data unable to display hebrew characters?

jimmyjazz1978
Starting Member

11 Posts

Posted - 2012-04-20 : 10:36:31

Usign Management Studio to view the data . In the text file the characters do not show correctly wither using notepad.

Bizzare

jimmyjazz1978
Starting Member

11 Posts

Posted - 2012-04-20 : 10:38:01

quote:
Originally posted by jimmyjazz1978

Usign Management Studio to view the data . In the text file the characters do not show correctly wither using notepad.

Bizzare

I imported a text file into the database using SSIS to be clear here.

Bizzare

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-04-20 : 10:39:44

what is the current collation on server, database, tables columns?

Shalom

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

jimmyjazz1978
Starting Member

11 Posts

Posted - 2012-04-20 : 11:58:58

How do I check that ? New to SQL SERVER ...

Bizzare

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2012-04-20 : 11:59:50

Well I don't think they will show correctly unless you set up your computer to display those character sets. Admittedly, my experience with non-Latin character sets is a bit limited. But, I recall having to do some special setup of Management Studio in order to correctly display Unicode characters sets.

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-04-20 : 14:38:21

1. right click on server and select properties: look for Server Collation on the right grid
2. right click on database and select properties: look for Collation on the right grid
3. right click on table and click on extended properties and check Collation on the right

what do you see?

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

jimmyjazz1978
Starting Member

11 Posts

Posted - 2012-04-25 : 09:10:17

1. SQL_Latin1_General_CP1_CI_AS
2. SQL_Latin1_General_CP1_CI_AS
3. SQL_Latin1_General_CP1_CI_AS

So basically I need to diplay HENREW name in database and then take it to an Excel Report after that .

Bizzare

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-04-25 : 09:59:01

You will need UNICODE to store and display Hebrew characters.

N 56°04'39.26"
E 12°55'05.63"

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-04-25 : 10:21:55

You will need to have your column datatype as nvarchar

create table #temp ( str Nvarchar(100) )
insert into #temp(str)values(N'??????????? ???????: ????')
select * from #temp
drop table #temp

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-04-25 : 10:27:49

unable to embed Hebrew in above post. check following site

http://dba.stackexchange.com/questions/13193/sql-server-collation-for-arabic-or-hebrew-and-english-and-french

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources