database zip files? // mySQL create table

[Ruslan Zasukhin]

On 07/2/1 6:12 PM, "Trevor DeVore" <lists at mangomultimedia.com> wrote:

>>> yes OBDC import
>>> problems start right with the first field
>> 
>> CREATE TABLE `stockvalving` (
>>   `record_id` bigint(20) NOT NULL default '0',
>>   `orig_record_id` bigint(20) default NULL,
>>   `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update
>> CURRENT_TIMESTAMP,
>>   `access` int(10) default '0',
>>   `tunername` varchar(20) default NULL,
>> 
>> -------------
>> Another anomaly of mySQL:
>> 
>>     they use single quotes around names
>>     even somehow not usual single quotes.
>> 
>> SQL92 require here to use DOUBLE quotes.
> 
> They aren't actually single quotes.  It is ASCII 96.  This is the
> default MySQL behavior but I imagine you can change this behavior in
> the database settings though.

1) Segey have add support of this "back single quotes" into Valentina
parser, so next build of Valentina will eat this.
   
 
2) yes, I also believe that mySQL or phpAdmin should allow specify what
quotes to use.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]