Null The column doesn’t have a specified type. Bit A bit or boolean value. Int1 An 8-bit integer value. Int2 A 16-bit integer value. Int4 A 32-bit integer value. Int8 A 64-bit integer value. Datetime4 A 32-bit datetime value. Float4 A 32-bit floating point value. Float8 A 64-bit floating point value. Money Money value. Datetime A TDS 7.2 datetime value. Money4 A 32-bit money value. Guid A unique identifier, UUID. Intn N-bit integer value (variable). Bitn A bit value in a variable-length type. Decimaln A decimal value (same as Numericn). Numericn A numeric value (same as Decimaln). Floatn A n-bit floating point value. Datetimen A n-bit datetime value (TDS 7.2). Daten A n-bit date value (TDS 7.3). Timen A n-bit time value (TDS 7.3). Datetime2 A n-bit datetime2 value (TDS 7.3). DatetimeOffsetn A n-bit datetime value with an offset (TDS 7.3). BigVarBin A variable binary value. BigVarChar A large variable string value. BigBinary A binary value. BigChar A string value. NVarchar A variable string value with UTF-16 encoding. NChar A string value with UTF-16 encoding. Xml A XML value. Udt User-defined type. Text A text value (deprecated). Image A image value (deprecated). NText A text value with UTF-16 encoding (deprecated). SSVariant An SQL variant type.

https://docs.rs/tiberius/0.10.0/tiberius/enum.ColumnType.html

for row in rows { let mut rowtext: Vec<String> = Vec::new(); for item in row.into_iter() { let output = match item { ColumnData::Binary(_val) => "binary data".into(), ColumnData::Bit(val) => val.unwrap_or_default().to_string(), ColumnData::Date(_val) => "don't know how to implement".into(), ColumnData::DateTime(_val) => "don't know how to implement".into(), ColumnData::DateTime2(_val) => "don't know how to implement".into(), ColumnData::DateTimeOffset(_val) => "don't know how to implement".into(), ColumnData::F32(val) => val.unwrap_or_default().to_string(), ColumnData::F64(val) => val.unwrap_or_default().to_string(), ColumnData::Guid(val) => val.unwrap_or_default().to_string(), ColumnData::I16(val) => val.unwrap_or_default().to_string(), ColumnData::I32(val) => val.unwrap_or_default().to_string(), ColumnData::I64(val) => val.unwrap_or_default().to_string(), ColumnData::Numeric(val) => val.unwrap().to_string(), ColumnData::SmallDateTime(_val) => "don't know how to implement".into(), ColumnData::String(val) => val.unwrap_or_default().as_ref().into(), ColumnData::Time(_val) => "don't know how to implement".into(), ColumnData::U8(val) => val.unwrap_or_default().to_string(), ColumnData::Xml(val) => val.unwrap().as_ref().to_string(), _ => "nada".into() }; rowtext.push(output); } let data = format!("{}\n", rowtext.join(",")); file.write_all(data.as_ref())?; } 14.09.22

https://github.com/prisma/tiberius/issues/101

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2022