1

Here are the characters in database ( last line ) : enter image description here

When I var_dump, the squared characters disapears: enter image description here

And I need to get that squared characters.

arshie92
  • 73
  • 1
  • 1
  • 10
  • What do you mean by "get that squared characters"? – Jay Blanchard Jan 20 '17 at 16:38
  • I mean the squared charaters showed in the table. – arshie92 Jan 20 '17 at 16:40
  • Looks like broken utf8. squared characters never used in real web. – JustOnUnderMillions Jan 20 '17 at 16:44
  • 1
    In php they look like new line characters (i.e. \r\n) which may not be renderable in the grid tool your viewing the data in. What is the result of `select gdetail, cast(gdetail as varbinary(32)) where gdtlastmod='1484240045'` (You would see 0d0a for \r\n) – Alex K. Jan 20 '17 at 16:45
  • IF they are coming out of your database fine through one client, but not through another, then it's probably that your other db client isn't set up for UTF8 (or to display whatever this character is if it's just a boring old ascii carriage return and line feed). Like.. it's not your data, it's your tool for viewing your data. No biggie. – JNevill Jan 20 '17 at 16:45
  • @AlexK. I get " Conversion from text to varbinary is not autorised ". When I try to insert \n it show 4 squars. So I need juste to find which characters correspond to 2 squars. – arshie92 Jan 20 '17 at 17:06
  • @JNevill Certainly. But is there a way to find which characters are showing like 2 squares ? – arshie92 Jan 20 '17 at 17:07
  • 2
    @AlexK. It is " \n " . I add it to the text to insert and it works. Thank to all of you. – arshie92 Jan 20 '17 at 17:18
  • @arshie92 you can add & accept your own answer to your question below. – Alex K. Jan 23 '17 at 11:27

1 Answers1

0

The 2 squared characters were finally " \r\n " .

arshie92
  • 73
  • 1
  • 1
  • 10