mULTI LANGUAGE SUPPORT IN SQL SERVER

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 2005 Forums

Transact-SQL (2005)

mULTI LANGUAGE SUPPORT IN SQL SERVER

Author

Topic

junaidKhan
Starting Member

3 Posts

Posted - 2008-11-11 : 05:32:46

I have a web page, that contains a text box -
users have to enter some ARABIC text into this textbox,
this data is to be

1. stored (when submit pressed)into SQL server database
2. Later I have to retrieve this data from database and show into a web page also.

How can I achieve this

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-11-11 : 05:34:10

store it in the Nvarchar data type column.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2008-11-11 : 05:44:13

and don't forget to mention N before inserting and retrieving column values

CREATE TABLE #TEMPtable
(ArabicData NVARCHAR(100))

INSERT INTO #TEMPtable (ArabicData) VALUES (N'yourarabicdata')

SELECT * FROM #TEMPtable WHERE ArabicData = N'filterarabicdatra'

DROP TABLE #TEMPtable

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-11-11 : 05:52:26

hopefully he uses sql parameters and doesn't have to worry about those things

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!

calvinkwoo3000
Yak Posting Veteran

98 Posts

Posted - 2014-07-30 : 05:48:39

Hi expert here,

I am sorry, i solve it because i declare it as varchar in my store procedure in stead of nvarchar.

i facing little difficulty here.
I using nvachar in my column named(message).
when i type insert command: insert into #table (message) Value (N'??') the chinese words stored correctly in table.
when i using store procedure, the chinese words not stored correctly, only shown "??".

can any expert gave me some advise?
Thank you

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources