junk characters when extract the float field to the text file

[Guest_imported]

I am using dstx8.0.1 on windows.
issue:
I have a blob field in the typtree (General/text/character,size-min=0/max=blank )
in the rule I have a DBQUERY(select floatfield,x,y,z from xyz table)writing the result to a file.
when I open the file the floatfield value displaying some junk characters (š™™™™Õ„) does any body has this problem.
Suggest me the approch to resolve this issue/

 

[BocaBurger]

What do you get from this query outside of WTX?
What DB?
Add a -T and see what is in the trace.




BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!

 

[Guest_imported]

Boca,

I am just retriving the information from the table that's it.The query is not a real query just a sample.
I am using the SQLServer8.0
=DBQUERY ("SELECT [Number], [XXXXfloat],[YYY] FROM [XXX].[dbo].[Tablename] order by [xxxxx] " ,"-MDQ xx_yy.mdq -DBNAME XXDB -t" )
I checked the .dbl its showing successfully retived records.

 

[Guest_imported]

What do you get from this query outside of WTX?
What DB?
Add a -T and see what is in the trace.

Thanks bocca that you remind me to check the trace file, I looked at and found DBTYPE_R8 field.
I did little bit research on that in sqlserver found that it is UTF-8 format so needs to do an explisit conversion for the
fields which have the data type DBTYPE_R8 .

I used the following command to populate actual value instead a junk characters in the output file.
CONVERT( VARCHAR(20), field ) AS fieldname .


I fixed the issue with your initiation boca.