Converting Codepages inline

Databases
1

Is it ok to do:

  ps.Bind(0, Ticket.ConvertEncoding(Encodings.WindowsANSI))

or is it safer to do the following (and if yes, why?):

Ticket = Ticket.ConvertEncoding(Encodings.WindowsANSI) ps.Bind(0, s)

2

Personal preference I would say. The second example (if you change s to ticket :slight_smile: ) is easier to read and the first example is more concise.

How often do you do this convert encoding? If in doubt do a profiling.

3

I Define everytime i receive Strings from a (non-SQLite) Database and Convert everytime i send Strings to the Database.
I am working with 7 mySQL and 1 MSSQL Databases in 1 Project.