Re: "Special Charactes"???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



NewMan,

SQL Server can store and retrieve any character string. These are not
special to SQL Server itself.

You are more likely to have trouble with your client software, depending on
how it is written, although I would hope that your ERP vendor is avoiding
the most obvious problems.

RLF

"NewMan" <CloakedRun2001@xxxxxxxx> wrote in message
news:ngatb4d55sti0bdopllm96c3dd7djf6en5@xxxxxxxxxx
We will soon be deploying MS SQL Server 2005 as a prelude to migration
into ERP software which uses MS SQL as the back-end database engine.

An issue has come up regarding "special characters". We are a company
that manufactures electronic assemblies, and the makers of the parts
we buy frequently use characters such as - " ' / % \, etc. The use of
these characters is imperative to specification of the exact part
required.

Does MS SQL Server 2005 Have a problem with these "special"
characters?

Also, we will be purchasing Software Assurance so that we can igrate
to MS SQL Server 2008 as soon as it is certified for use by our ERP
vendor. Does SQL 2008 also have the same problems with "special"
charaters???

All comments and guidance greatly appreciated.

Thanks


.



Relevant Pages

  • Re: Stored proc with version number ?
    ... in addition to letter characters from other languages. ... Certain symbols at the beginning of an identifier have special meaning ... in SQL Server. ... I choose> the existing stored proc uspTableSave and right click Properties. ...
    (microsoft.public.sqlserver.programming)
  • Re: Can you use osql in DTS?
    ... each one of these queries has in it the same first 18 characters (or ... it from Query #3. ... > Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... each one of these queries has in it the same first 18 characters (or ... it from Query #3. ... > Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)
  • Re: sendStringParameterAsUnicode: How to insert unicode data corre
    ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ... The destination columns are nvarchar and store unicode data correctly. ... is unable to display the characters you have. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: How to store HTML code in SQL server table
    ... but varchar cannot be properly used with unicode ... and has a maximum length of 8000 characters. ... > I support the Professional Association of SQL Server and it's> community of SQL Server professionals. ... >> I'm creating something like a web site builder in ASP.Net, and I need to>> store an HTML code in the SQL server table. ...
    (microsoft.public.sqlserver.server)