Issue with UnsafePointer in SQLite project in Swift

by

This should work:

let address = sqlite3_column_text(statement, 0)
let string = String.fromCString(UnsafePointer<CChar>(address))

Update for Swift 3 (Xcode 8), compare Swift 3: convert a null-terminated UnsafePointer<UInt8> to a string:

let string = String(cString: sqlite3_column_text(statement, 0))

Update:

sqlite3_column_text() returns an implicitly unwrapped optional, and that is why you can pass it to String(cString:) directly.

But according to Column methods, error and NULL handling #41, the return value can be null (in an out-of-memory situation, or if called with a NULL column type). Therefore it is safer to do

if let text = sqlite3_column_text(statement, 0) {
    let string = String(cString: text)
    // ...
} else {
    // sqlite3_column_text() returned NULL
}

More Related Contents:

  1. Sqlite File Location Core Data
  2. Use and Access Existing SQLite Database on iOS
  3. Objective-C Wrapper for CFunctionPointer to a Swift Closure
  4. Global Variable Not Update ( Swift ) [closed]
  5. Swift extract regex matches
  6. How to group by the elements of an array in Swift
  7. Save images in NSUserDefaults?
  8. In absence of preprocessor macros, is there a way to define practical scheme specific flags at project level in Xcode project
  9. reloadData() of UITableView with Dynamic cell heights causes jumpy scrolling
  10. How to create NS_OPTIONS-style bitmask enumerations in Swift?
  11. MKMapView: Instead of Annotation Pin, a custom view
  12. Extract RGB Values From UIColor
  13. Changing specific text’s color using NSMutableAttributedString in Swift
  14. How to reload data in a TableView from a different ViewController in Swift
  15. Passing arguments to selector in Swift
  16. NSURLConnection sendAsynchronousRequest can’t get variable out of closure
  17. How to capitalize each word in a string using Swift iOS
  18. Why is main window of type double optional?
  19. Positioning UITabBar at the top
  20. Usage of protocols as array types and function parameters in swift
  21. How to allow user to pick the image with Swift?
  22. Module compiled with Swift 4.2.1 cannot be imported by the Swift 5.0 compiler
  23. swift NSTimer in Background
  24. How to add image in UITableViewRowAction?
  25. HTML Format in UITextView
  26. Bounding Box from VNDetectRectangleRequest is not correct size when used as child VC
  27. How to copy text to clipboard/pasteboard with Swift
  28. GM release of Xcode 6 compile
  29. Rotation only in one ViewController
  30. Difference between static function and singleton class in swift [closed]

Leave a Comment