On 2013-07-14 19:00, Daniel Simoes de Ameida wrote: > > When the FieldDefs.Size properties is defined and we are trying to > save UTF8 characters with accented words, the Data is Truncated.
Yeah, I have experienced that too. There really should be a .Size and .DataSize property - or something similar. Even setting the database to use Unicode text fields doesn't solve the problem either - in then messes with the .Size property value in SqlDB. My work-around is to simply use VarChar(), and make sure you add some extra space for those Unicode fields. Then hold thumbs that the client apps don't hit that limit. eg: I might have a business object that says a field is 100 "characters" long. This limit gets applied to the user interface too. But the database field is actually defined as VarChar(150). This gives me 50 bytes extra for the occasional Unicode character. Definitely not an ideal solution though. Regards, - Graeme - -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus