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 2000 Forums
 SQL Server Development (2000)
 Language Insetiion in database table

Author  Topic 

harish
Starting Member

2 Posts

Posted - 2005-05-08 : 02:33:21
hello there,

Many Greetings,

Problem : I have an personal info form, which use to fill with Local language and want to insert the values in database in Local language.

I have made the form , Values can be inserted in japanes in the form text box.
When fetch the values from textbox with N'textbox.text with simple insert statement directly with out store procedure work very well.

eg. insert into table(name) values(N'textbox.text)

But the same with store procedure does not insert the values in Local language instead it's insert the QUestion mark..for the Indian language..?????


can any one help...does i have to set any variable for language in store procedure, or i have to N' it in store procedure , if yes then how to concate it..

PLS HELP ME ASAP..my dead line is near.. pls..

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-05-08 : 03:30:43
What datatype is the name column on the table?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -