August 27, 2008 at 11:25 am
Hi All
I am facing a new Problem, i need to insert Greek characters into SQL server on Default SQL Server Settings. this cant be done since the characters has got some specail characters on Greek, is there any way that i can do to insert into the normal SQL server and insert and select from the table.
In other words, i need to insert Greek String into a normal SQL server and then select them from normal SQL server table.
Has any one faced this kind of problem. please post me on this, and help me on this
Cheers
Sujith
August 27, 2008 at 12:01 pm
I believe that you just use NVarchar(..) for that.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 27, 2008 at 12:08 pm
Here's an example :
select nchar(0x3A0)
This displays the Greek capital letter Pi. This can esialy be stored and retrieved from any column in a table with an NChar, NVarchar datatype.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 3:57 am
Thanks mate, this will store some other characters, if i select from the database then i get some other characters instead of actual greek characters, is it possible to insert the actual character set as it is, so when i select from the database that will make things much more easy since we are going to include this on out main systems that are english.
Cheers
🙂
August 28, 2008 at 4:04 am
CrazyMan (8/27/2008)
... i need to insert Greek characters into SQL server on Default SQL Server Settings.
Problem is you want to do some non-default stuff in a default configured environment.
I would take a deep breath then migrate my environment to Unicode and be happy forever 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 28, 2008 at 6:55 am
CrazyMan (8/28/2008)
Thanks mate, this will store some other characters, if i select from the database then i get some other characters instead of actual greek characters, is it possible to insert the actual character set as it is, so when i select from the database that will make things much more easy since we are going to include this on out main systems that are english.
(While I suspect that PaulB may be right, lets break this down and see...)
CrazyMan: No, this does not store "some other characters", this stores the actual Greek Characters. I was demonstrating that using the NCHAR() function, because I do not have Greek set up on my client and this way anyone who read it can try it. It demonstrates that a default SQL Server can indeed store and display Greek characters.
Can you tell us what tool or client program you are using that will be trying to put Greek text into SQL Server? Virtually anything that runs on Windows in the last 10 years uses Unicode internally and I am uncertain how you could be using Greek on your clients without already being on Unicode.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 28, 2008 at 9:12 am
rbarryyoung : this is a greek text that we receive from the greek user, once we receive the text then we insert them into a table with other information like date and some other flags, As u said that i can use nVarchar for this, this will almost double my table size, there is a limitation on nvarchar, i need to use N before the string to insert the actual greek characters into the SQL table, we are using Java application for this, i am not sure wether we have to do that in Java as well.
My problem is that we are increasing our business across world, so it will be better to change to unicode, but will there be any performance issues when using nvarchar to varchar( the one thing i know is about the size)???
🙂
August 28, 2008 at 9:33 am
Yes, it takes more space. But Unicode/NChar is the solution for this and this is exactly the reason that it exists.
I don't know about the "N" before the quote, it depends on your API and specific calls and I am not familiar with the Java APIs. If your are just passing command strings (which it sounds like you are) then yes, you would need to add the "N".
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply