On Tue, 16 Sep 2008, Volkan YAZICI wrote: > Hi, > > How can I represent a "nvarchar" data type (of Sybase/MSSQL) in > XML::SQLFairy format?
I'm pretty sure that format (producer/parser set) doesnt care at all what you put as the "data_type". so just put "nvarchar" in it. The SQLServer and Sybase Producers dont convert any other known type to nvarchar, so that's the only way to get it. The conversion of data_types happens on the producer side of things, so the store itself (the xml) doesnt need to have any particular set. > BTW, is there a fully detailed syntax documentation for XML::SQLFairy > format? I also couldn't figure out how to represent a foreign key. > No, fraid there isnt. We could do with one though. ::Producer::XML::SQLFairy should be fairly straightforward to read, if you want to have a go at it. Jess ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ -- sqlfairy-developers mailing list sqlfairy-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
