Globilization in SQL Server

  • Dinesh Asanka

    SSChampion

    Points: 11058

    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/

  • Reginaldo Ribeiro

    Grasshopper

    Points: 17

    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.

  • Dinesh Asanka

    SSChampion

    Points: 11058

    what are the data types that are using

    use nvarchar , nchar and ntext




    My Blog: http://dineshasanka.spaces.live.com/

  • mjschwenger

    SSCarpal Tunnel

    Points: 4019

    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.

  • Dinesh Asanka

    SSChampion

    Points: 11058

    Sorry for the mistake. thankx for the information




    My Blog: http://dineshasanka.spaces.live.com/

  • Kurt Hayes

    SSC Rookie

    Points: 33

    Globalization is misspelled.

  • Dinesh Asanka

    SSChampion

    Points: 11058

    Major mistake!!!

    will be corrected




    My Blog: http://dineshasanka.spaces.live.com/

  • Dinesh Asanka

    SSChampion

    Points: 11058

    Corrections are done. Title caption needed to be corrected.




    My Blog: http://dineshasanka.spaces.live.com/

  • jcb

    SSCertifiable

    Points: 6574

    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

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply