BCP IN ISO-8859-1 (ISO-LATIN-1) TYPEFACE
May 25, 2006I NEED TO BCP DATA FROM A TABLE TO BE COMPLIANT WITH THE
ISO-8859-1 (ISO-LATIN-1) TYPEFACE
IS THERE A SWITCH I CAN USE TO TAKE CARE OF THIS.
EMAD
ADVERTISEMENT
Multilingage/multi Charset (latin/greek...) In 1 DB ?
Nov 12, 2004Is it possible to have in the same MsSQLServer database several languages:
French, english, german, spanish... (latin langages)
but also langages with different characterset (greek, cyrilic...)
What should be the type of data (char ou nchar(unicode)) ?
what should be the colation ?
Thanks
Unwanted Conversion Of Non Latin ASCII Characters
Oct 27, 2006hi
we get ASCII data inserted into a SQL Server database by ODBC connection from an old UNIX system.
Example: INSERT INTO test.db VALUES ('123abc', '456ĐĐ Đ')
All characters > 128 are converted to "?" automatically.
We tried to setup the database to the appropriate codepage, but we allways get "?" inserted.
MSSQL With Different Charsets, Cyrrilic(macedonian), Latin(Swedish)....
Jan 2, 2008Hi!
What kind off settings do I use if Iam gone have diffrent languages on the databse?? What kind of collections settings do I use then If Iam going to have macedonia(Cyrillic), Swedish, and lots of other contries???
What kind of collection Seetings do I use under the installation of the MSSQL Server 2005?
Ignore Latin And Other Foreign Characters In Text Search.
Apr 22, 2008Hi, i have a query that goes like this
select *
from Users
where UserName Like =@Username;
the values for 'UserName' go like this
Adrián
Jesús
Fernández
Güero
all of them have spanish accents. is there a way to make the "like" value to ignore the spanish characters? (á, é, í, ó, ú, ü, etc)
That is because the user will not always write "Jesús" they will write "Jesus" or they will not write "Adrián" they will write "Adrian"
so is there any way to tell the SQL Server engine to ignore those characters?
thanks!!!
Is There One Collation That Includes All The Eastern Europen Languages And Latin 1 Charset.
Jul 13, 2006Can I specify a collate value for a column in a table that includes all the possible languages in the world or atleast Latin 1 and Eastern European languages.
My DB Collation is set to Latin 1 and the columns in the tables are all nvarchar or ntext, but certain hungarian characters are not displayed correctly.
What do all these collation codes represent:
SQL_EBCDIC037_CP1_CS_AS
211
SQL_EBCDIC273_CP1_CS_AS
212
SQL_EBCDIC277_CP1_CS_AS
213
SQL_EBCDIC278_CP1_CS_AS
214
SQL_EBCDIC280_CP1_CS_AS
215
SQL_EBCDIC284_CP1_CS_AS
216
SQL_EBCDIC285_CP1_CS_AS
217
SQL_EBCDIC297_CP1_CS_AS
They seem generic. Is there one collation that includes all the Eastern Europen Languages and Latin 1 charset. Please let me know.
Thanks,
Manisha
DB Engine :: Chinese Collation That Has Latin Case-insensitive Characters?
Aug 21, 2015I don't quite understand what I am asking for so hopefully this is enough to get an answer or some explanation.
Using SQL2014 I need to use a Chinese collation. I have been told that even with a Chinese collation Latin characters are there. Is there a Chinese collation that will provide Latin case-insensitive behavior?
How To Support Multiple Language(Latin,chinese,japanese,korea) In One Report When Exporting To PDF Format
Feb 28, 2007We should support multiple language(Latin,chinese,japanese,korea) in one report when exporting to PDF format in reporting service. We have used Arial Unicode as our font. But when we exported the report, the korean language item can not be displayed. Any idea on that? Thanks a lot.
View 3 Replies View Related