Error when loading Polish characters from BBDD

Santiago Martin

• May 16, 2023 05:55

When loading 2 equal labels, but one from the database and another with embedded characters.
The one from the bbdd does not print the special characters and the other does.

 

We do not know what configuration of the database or of the fields must be applied so that the characters appear correctly.

 

Thanks

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • May 16, 2023 08:50

  The two texts fields are using different fonts entirely, have you tried using the same font on the label as in the database? 

  0
• 

  Santiago Martin

  ★ BarTender Hero ★

  • May 17, 2023 05:15

  We had already tried it and it gave the same problem.
  We have managed to solve it, changing the load sentence of the database.
  We believe that the problem was that when loading the statement the data types were changed from Nvarchar to Varchar, and it did not happen that it was UNICODE information.
  We have solved it by putting in the statement as follows: "Select N'Valor1', N'Valor2', N'Value 3' from table"

  0

Please sign in to leave a comment.