Migration with Strange Characters?

Question

The data is from a bank Firebird and even opening with official tools the characters do not come in the "format" br, for example:

ÁGUA vem µGUA
PÃO  vem PÆO

Find a website that provides a special character, for example µ it returns the value of the character in decimal, octal, etc:

Website: http://unicodelookup.com/#µ/1

In the above example the site returns the value decimal 181 for the character µ. If we use the shortcut ALT+181 he returns Á which is exactly the letter this code represents in the first example above. I tried to use var characters = Encoding.ASCII.GetChars(new byte[] { 181 }); but go back ? instead of Á.

My question is:

Is there a function that simulates the code generated by ALT+181 to return a character?

I accept response in c# or vb6

Answer 1

You can make a Backup and a Restore from your database using the following commands from Gbak for correction of UNICODE.

-FIX_FSS_D(ATA)       fix malformed UNICODE_FSS
-FIX_FSS_M(ETADATA)   fix malformed UNICODE_FSS metadata

Follow an example of the Restore command.

"C:\Program Files (x86)\Firebird\Firebird_2_5\bin\gbak.exe" -se service_mgr -c -v -user sysdba -password masterkey "d:\base de dados\teste.fbk" "d:\base de dados\teste.fdb"-fix_fss_m win1252 -FIX_FSS_D win1252

For more information about commands go to

https://www.firebirdsql.org/pdfmanual/html/gbak-cmdline.html