FreeTDS Development Group

[Francis Smit <francis AT oztel.com>]

Umm this works fine for me I can do:

INSERT INTO star(stars) Values('*')
SELECT * FROM Test.dbo.star

Are you by any chance doing

INSERT INTO star(stars) Values("*")
SELECT * FROM Test.dbo.star

or equivalent if you are the MSSQL Server is thinking
that you want the field (*) the string (*) is denoted as
'*' or any string can be 'string' but never "string".


Karl Pielorz wrote:

> Hi All,
>
> I know this is off topic (probably) - and after having seen the difference
> between MySQL and MS-SQL V7 on inserting ' (quotes), I can probably guess
> where the problem lies (me)...
>
> Anyone know why I can't seem to insert a "*" (asterisk) into our MS-SQL V7
> server via FreeTDS?
>
> I can do the same in Delphi (not a real good comparison) by just setting the
> column value to "*", alas not from PHP/FreeTDS though...
>
> Any suggestions, or pointers would be gratefuly received...
>
> -Karl
>
> ---
> You are currently subscribed to freetds as: francis AT oztel.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

--

                                           Grisly    . oo
                                                      `oO
Francis Smit


Knowledge By Design/OzTel
Suite 201, 683 George st
Sydney 2000 NSW

mailto:francis AT kbd.com.au

Tel: +61 2 9212 1399
Fax: +61 2 9212 5727
___________________________________
m$: How can we stuff you up today?