Log Table Query ID - has strange control character in it?

Database
Enthusiast

Log Table Query ID - has strange control character in it?

Hi,

 I am pulling log table data into a flat file using the TD extract command. I am seeing some type of control character or special characters in the query id. I am pretty certain it's a surrogate key, so it seems it should just be a number of sorts. I have a photo of a small piece of the extract from Notepad ++

 

 

TD-Log-QueryID-SpecChar.jpg

 

Any ideas as to WHY there are either control characters in the query id in the log table.... or why the extract command is creating them in the extract process?

 

Alex

 

2 REPLIES
Senior Apprentice

Re: Log Table Query ID - has strange control character in it?

Looks like a two byte binary value, which is usually the result of exporting a concatenated VarChar using FastExport in Text format (i.e. the length of the VarChar).

 

Depending on the number of rows you better use BTEW Export or switch to TPT, which supports native Deleimited output.

Enthusiast

Re: Log Table Query ID - has strange control character in it?

First - Thanks for your reply.

Secondly.... I'll be exporting an entire day's worth of log data, which can be thousands (sometimes hundreds of thousands) of rows.

 

So .... which export tool do you think is best?