Globilization in SQL Server

  • 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/

  • 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.

  • what are the data types that are using

    use nvarchar , nchar and ntext




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

  • 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.

  • Sorry for the mistake. thankx for the information




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

  • Globalization is misspelled.

  • Major mistake!!!

    will be corrected




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

  • Corrections are done. Title caption needed to be corrected.




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

  • 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 8 (of 8 total)

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