Invalid characters

fred_m

Hi guys,

I'm using this sql sentence:

select CONVERT(binary(5),field1)'field1' from table1
field2=0
group by CONVERT(binary(5),field1)
order by
CONVERT(binary(5),field1)

And I Got this result on php if I open page on firefox:

F�R�E�D�_�0�1���������������������������

If I open page on Internet Explorer I got the correct one;

FRED

There is any function on php that remove this invalid characters ?

Thanks.

Fred

NogDog

Well, maybe you're doing something beyond my level of knowledge; but why are you casting the field data to a binary type and then expecting it to output as normal text? (I don't know why IE outputs it differently than FF, but then I don't know why you would expect any browser to output it as normal text.)

fred_m

I need diferentiate the case of my result.
According this article http://support.microsoft.com/kb/171299/pt , for do this in sql server I need to convert to binary.

After conversion, how can i convert back to normal text ?

Thanks.

Fred

bradgrafelman

Whoa, a Microsoft KB article? That must mean there's a better way to do it! 🙂

What exactly do you mean by "diferentiate the case of my result" ?

fred_m

I use this KB because my bd, unfortunately, is SQL Server. :eek:

Means that Fred should be different than FRED.

Thanks.

Fred

bradgrafelman

What kind of SQL server are you running? Since you linked to an MS KB article, I'm guessing MSSQL?

fred_m

Microsoft SQL Server 2005.

bradgrafelman

Try something like this:

select field1
FROM table1
WHERE CAST(field1 AS VARBINARY) = CAST('Fred' AS VARBINARY)

Also note that you can change the collation of a table/database to be strictly case-sensitive by default.