Re: character(s) that cannot be stored in DB

From: Owen (Owen_at_discussions.microsoft.com)
Date: 09/30/04


Date: Wed, 29 Sep 2004 21:31:01 -0700

Oh yes, I forgot to mention the SQL Server is Traditional Chinese version,
does it make any different in this case?

"Owen" wrote:

> Thanks for your reply Tibor.
>
> I am in a situation where the company that is hosting my
> web site has told me that I cannot enter characters ' and
> + in the column as it will cause problem, I can enter "
> however. What can you suggest that I tell them as I do
> need to input those characters.
>
> Thanks
>
> Owen
>
> >Not really. But the character repertoire is based on the
> collation selected for the
> >column/database/server.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> >
> >
> >"Owen" <owen_lin@hotmail.com> wrote in message
> news:12f901c4a5f1$04a6acf0$a601280a@phx.gbl...
> >> Does any one know if there're certain character(s) that
> >> cannot be stored in the DB which is similar to Windows
> >> cannot have " or * etc.?
> >>
> >> Thanks
> >>
> >> Owen
>



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)

Loading