1. william yau
  2. PowerBuilder
  3. Monday, 29 November 2021 10:29 AM UTC

Hi Guru

 on my old powerbuilder 7.0 and sql2000 program,  my program can display special characters on my database. but 

migration into powerbuilder 2019 and sql2016 database that cannot display special characters , is there anything missing. 

WILLIAM

(1) 2000 server database 

 

(2) powerbuilder 7.0  display 

 

 

 

william yau Accepted Answer Pending Moderation
  1. Friday, 3 December 2021 06:32 AM UTC
  2. PowerBuilder
  3. # 1

Hi 

I found old PB 7.0 can display non unicode character . but pb 10. or later only display unicode character. how can display non-unicode 

on powerbuilder 2019 

 

 

William

 

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 29 November 2021 15:51 PM UTC
  2. PowerBuilder
  3. # 2

The new database in SQL 2016 needs to use datatype nchar or nvarchar instead of char or varchar for columns likely to contain accented characters. The nchar and nvarchar datatypes allow for storing Unicode characters.

 

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 29 November 2021 13:28 PM UTC
  2. PowerBuilder
  3. # 3

Hi William;

  Since PB v10 and higher are fully Unicode (UTF-16) compliant, my guess is that either the DBMS migration, DB settings and/or DB client used could be the source of your problem.

   Have you tried other SS tools to see if they can display the special characters OK?

Regards ... Chris

Comment
  1. william yau
  2. Friday, 3 December 2021 06:33 AM UTC
what 's SS tools ?
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 3 December 2021 15:32 PM UTC
SQL Server
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.