Hi Lukas
- What database are you using?
- MySQL 5.6
- What jOOQ version are you using?
- 3.6
- What do the table/columns look like (CREATE TABLE...)?
- CREATE TABLE `tblLogAdcentral` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account_id` int(10) unsigned NOT NULL DEFAULT '0',
`account_type` enum('publisher','advertiser','general','prospect') NOT
NULL DEFAULT 'general',
`salesrep_id` int(10) unsigned NOT NULL DEFAULT '0',
`note` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`note_type` enum('BILLING','EMAIL','NOTE','SYSTEM','ZENDESK') NOT NULL
DEFAULT 'NOTE',
`date_action` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`followup_date` date DEFAULT NULL,
`followup_time` time DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `followup_date` (`followup_date`),
KEY `account_id` (`account_id`,`account_type`),
KEY `date_action` (`date_action`)
) ENGINE=InnoDB AUTO_INCREMENT=38508492 DEFAULT CHARSET=latin1
- How do you insert data with jOOQ?
final TbllogadcentralRecord noteRecord = note.getInternalRecord();
noteRecord.attach(adcentraldb.configuration());
noteRecord.store();
On Monday, May 11, 2015 at 11:59:26 AM UTC-5, Lukas Eder wrote:
>
> Hello Bryan,
>
> Thanks for your enquiry. In order to best help you track down this issue:
>
> - What database are you using?
> - What jOOQ version are you using?
> - What do the table/columns look like (CREATE TABLE...)?
> - How do you insert data with jOOQ?
>
> Depending on your SQLDialect, I'm thinking that jOOQ might be casting your
> bind variables to VARCHAR (instead of NVARCHAR). Also, jOOQ internally uses
> PreparedStatement.setString() (not setNString()), which might be causeing
> trouble here.
>
> Best Regards,
> Lukas
>
> 2015-05-11 18:50 GMT+02:00 <[email protected] <javascript:>>:
>
>> hello,
>>
>> so I'm trying to write russian characters ("Здравствуйте") into the db,
>> but somewhere jooq it gets replaced with all question marks ("???????
>> ?????"). I figured it has something to do with specifying the character
>> encoding in jooq, but I'm not sure where that would take place or how that
>> would be done.
>>
>> thanks
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "jOOQ User Group" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
