Varbinary encoding

Question

I got a varbinary field in my database, and got some problems with displaying special (Polish) characters like ąśćężźć.

Example: SELECT local_name from items WHERE id = 140 returns: Pieczęć, the problem appears when I want to print this data on my website (encoding UTF-8 there), then the Pieczęć turns into the following string: Piecz�� tried also to use utf8_encode() PHP function but it gives the following result: Pieczêæ.

How can I solve that so it will print the special characters without problem?

Why not just use a `VARCHAR` with UTF-8 charset? I'm not sure it will solve the problem, it's just a general comment... — DaveRandom, Jun 28 '12 at 22:09
why are you storing non binary data in a binary field type ? — , Jun 28 '12 at 22:13
Do you also need to specify the character set in the meta tag or headers? — Josh, Jun 28 '12 at 22:32
@Josh Yes, because without that my page won't support those special characters also. — Categle, Jun 28 '12 at 22:40

score 0 · Answer 1 · edited May 23 '17 at 10:34

0

same adivce as here: https://stackoverflow.com/a/11254131/1489924

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" >

and/or

SET NAMES 'utf8'

worked for me in most situations. Good luck!

edited May 23 '17 at 10:34

Community

1
1

answered Jun 28 '12 at 23:13

Razvan Pandor

23
1
3

Varbinary encoding

1 Answers1