Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Globilization in SQL Server Expand / Collapse
Author
Message
Posted Wednesday, June 22, 2005 3:47 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:38 PM
Points: 912, Visits: 209
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dasanka/globilizationinsqlserver.asp






My Blog: http://dineshasanka.spaces.live.com/
Post #193255
Posted Monday, July 4, 2005 6:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 11, 2007 6:21 AM
Points: 1, Visits: 1
Hello. Sorry about bad english. We are a Brazilian Sotware Producer and we develope a program that runs in Brazilian Portuguese, German, English, French, Italian, Spanish, and Turkish for a german customer using MSDE and we had too many problems with regional options and language. At end of development we choose for to delive the database language files and attach them on customer´s sql server machines to prevent data errors. But, how to perform when a customer tries to insert a string that uses simple quote mark, like: " Copo D´Água " ? The product can be running in various MSDE different languages. We will don´t know which of them. My regards. Reginaldo.
Post #196672
Posted Monday, July 4, 2005 6:54 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:38 PM
Points: 912, Visits: 209

what are the data types that are using

use nvarchar , nchar and ntext








My Blog: http://dineshasanka.spaces.live.com/
Post #196687
Posted Tuesday, July 5, 2005 9:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, March 20, 2009 5:30 PM
Points: 213, Visits: 65
There is an error in Bulgarian months - for april - needs to be corrected - well, I do not have a cirilic right now and I cannot write it down but it's wrong...
Hope this will help.



Post #197002
Posted Wednesday, July 6, 2005 12:13 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:38 PM
Points: 912, Visits: 209
Sorry for the mistake. thankx for the information






My Blog: http://dineshasanka.spaces.live.com/
Post #197253
Posted Wednesday, July 6, 2005 1:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 31, 2005 3:17 PM
Points: 13, Visits: 1
Globalization is misspelled.

Post #197677
Posted Wednesday, July 6, 2005 10:04 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:38 PM
Points: 912, Visits: 209

Major mistake!!!

will be corrected








My Blog: http://dineshasanka.spaces.live.com/
Post #197845
Posted Sunday, July 10, 2005 6:40 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 27, 2014 10:38 PM
Points: 912, Visits: 209
Corrections are done. Title caption needed to be corrected.






My Blog: http://dineshasanka.spaces.live.com/
Post #199104
Posted Tuesday, July 4, 2006 4:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:46 AM
Points: 2,734, Visits: 943

To avoid single quoted problems make sure to validate the input. Use of single quotes is a well know SQL inject attack used from hackers. Try replace each single quotes for two single quotes.

I´m also a brazilian developer and the SQL server date handle provide most os bad time. First if the SQL is installed at us language setting the session language is ineffective. This is a bug of SQL server.

My personal experience proved reset default server language, set dateformat, set session language and set user language sometimes dont works!

In addiction for the problems the use of diferent collations at the same database can destroy the simpliest comparation "a" = "a" can be evaluate to false!

Consider the cenario where u send updates for the customer to create a new table. The SQL server at the customer have a different default collation. Expect for a lot of problems.

And at end the britanic imperial system default for all US softs is weird.

 

Jean

Post #292006
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse