Re: character(s) that cannot be stored in DB
From: Owen (Owen_at_discussions.microsoft.com)
Date: 09/30/04
- Next message: Owen: "Re: character(s) that cannot be stored in DB"
- Previous message: Dan Guzman: "Re: VB.Net access to SQL Server system table for stored procedures"
- In reply to: Tibor Karaszi: "Re: character(s) that cannot be stored in DB"
- Next in thread: Owen: "Re: character(s) that cannot be stored in DB"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Sep 2004 21:19:03 -0700
I spoke to the company that is hosting my web site and DB, although I did not
asked them in details as to what sort of problem it might cuase or have
caused in the past, but they did told me that it has been a problem in the
past where their hosting site(s) needing to store ' within SQL and have
encountered some issue.
They have asked me to seek advice on their behalf as to what can/should they
do to overcome such problem.
Many thanks
Owen
"Tibor Karaszi" wrote:
> Ask them what they mean by "it will cause problem". SQL Server can certainly handle this. Who wrote
> the application you are using?
>
> --
> 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:35f801c4a601$fd6b9200$a501280a@phx.gbl...
> > 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
>
>
>
- Next message: Owen: "Re: character(s) that cannot be stored in DB"
- Previous message: Dan Guzman: "Re: VB.Net access to SQL Server system table for stored procedures"
- In reply to: Tibor Karaszi: "Re: character(s) that cannot be stored in DB"
- Next in thread: Owen: "Re: character(s) that cannot be stored in DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
