Collections:
Casting Strings to Wrong Code Pages in SQL Server Transact-SQL
What Happens If Strings Are Casted into Wrong Code Pages in SQL Server Transact-SQL?
✍: FYIcenter.com
In SQL Server, different collations may use different code pages. For example:
If you are casting a string of characters from one code page to a different code page, some characters will be converted to similar characters. For example
PRINT 'Français: eéèê-aà-oô'; -- The default code page PRINT 'Français: eéèê-aà-oô' COLLATE French_CI_AI; -- Code page 1252 PRINT 'Français: eéèê-aà-oô' COLLATE Polish_CI_AS; -- Code page 1250 PRINT 'Français: eéèê-aà-oô' COLLATE Cyrillic_General_CI_AS; -- Code page 1256 Français: eéèê-aà-oô Français: eéèê-aà-oô Français: eéee-aa-oô Francais: eeee-aa-oo
⇒ CHAR(n) - Truncating/Padding Strings in SQL Server Transact-SQL
⇐ COLLATE Clause in SQL Server Transact-SQL
2017-05-13, 2438🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...